﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using EmoneyWeiXinCommon;
using System.Data.SqlClient;

namespace EmoneyWeiXinDAL
{
    public class UsersFor917DAL
    {
        public static DataTable GetUsersByYzm(string yzm)
        {
            string sql = "SELECT * FROM UsersFor917 WHERE YZCode=@YZCode;";
            string sql2 = "UPDATE UsersFor917 SET IsDC=1,DCTime=GETDATE() WHERE YZCode=@YZCode;";//修改登场状态
            sql = sql + sql2;
            SqlParameter[] paras = 
            {
              new SqlParameter("@YZCode",yzm)
            };
            DataTable dt = SQLHelper.ExecuteGetTable(Config.EmoneyWeiXin, System.Data.CommandType.Text, sql, paras);
            return dt;
        }


    }
}
